{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Part-A","Part-B","Part-C","Part-D","Part-E","Data Validation","Drop-downs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Part-A","index":0,"n_rows":91,"n_cols":7,"rows_kept":91,"cut":false,"hidden":false,"merged":[[67,3,67,4],[57,3,57,4],[0,6,0,7],[1,6,1,7],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[5,6,5,7],[6,6,6,7],[7,6,7,7],[8,6,8,7],[19,3,19,4],[11,3,11,4],[30,3,30,4],[2,6,2,7]]}
[null,"Part A - District-Level Information",null,null,null,"School District Name","Greene Central School District"]
[null,null,null,null,null,"BEDS Code","080601"]
[null,null,null,null,null,"School Year","2018-19"]
[null,"I) Contact Information"]
[null,null,null,null,"Mailing Address"]
[null,"Contact First & Last Name","Mark A. Rubitski",null,"Street Address Line 1",null,"40 S. Canal Street"]
[null,"Title of Contact","Business Manager",null,"Street Address Line 2"]
[null,"Email Address","mrubitsk@greenecsd.org",null,"City",null,"Greene"]
[null,"Phone Number","(607)656-9204",null,"Zip Code",null,"13778"]
[]
[null,"II) Total Amount of District Spending Allocated to Individual Schools"]
[null,null,null,"Funding Source"]
[null,"A) Total Major Operating Funds Spending","Total Spending","State/Local","Federal"]
[null,"General Fund Total Expenditures & Transfers",26448955,26448955,0]
[null,"Special Aid Fund Total Expenditures & Transfers",823521,123521,700000]
[null,"School Food Services Fund Total Expenditures & Transfers",600450,270200,330250]
[null,"Debt Service Fund Total Expenditures & Transfers",0,0,0]
[null,"Total Major Operating Funds Spending",{"$f":"SUM(C14:C17)","v":27872926},{"$f":"SUM(D14:D17)","v":26842676},1030250]
[]
[null,null,null,"Funding Source"]
[null,"B) Exclusions for Non-Instructional Costs","Total Spending","State/Local","Federal"]
[null,"Interfund Transfers",351163,351163,0]
[null,"Debt Service",4049842,4049842,0]
[null,"School Food Services Fund",600450,265600,334850]
[null,"Community Services",13500,13500,0]
[null,"Adult/Continuing Education",71550,71550,0]
[null,"Transportation",1143967,1143967,0]
[null,"Employee Benefits Allocated to Above Purposes (see IV below)",445787,445787,0]
[null,"Total Non-Instructional Cost Exclusions",{"$f":"SUM(C22:C28)","v":6676259},{"$f":"SUM(D22:D28)","v":6341409},334850]
[]
[null,null,null,"Funding Source"]
[null,"C) Exclusions for Tuition/Payments to Non-District Schools","Total Spending","State/Local","Federal","Total Pupils "]
[null,"Charter School Tuition",0,0,0,0]
[null,"Services Provided to Charter Schools",0,0,0,0]
[null,"Other School Districts (Excl. Special Act Districts)",20000,20000,0,2]
[null,"Prekindergarten Community-Based Organizations",0,0,0,0]
[null,"BOCES Instructional Programs (Full-time Only)",2074655,2040217,0,90]
[null,"SWD School Age-School Year Tuition",0,0,0,0]
[null,"SWD Early Intervention Program Tuition",0,0,0,0]
[null,"SWD - Preschool Education (§4410) Tuition",0,0,0,0]
[null,"SWD - Summer Education (§4408) Tuition",105000,105000,0,15]
[null,"State-Supported Schools for the Blind & Deaf (§4201) Tuition",0,0,0,0]
[null,"Services Provided to Nonpublic Schools",316000,316000,0,1]
[null,"Total Tuition/Payments to Non-District Schools Exclusions",{"$f":"SUM(C33:C43)","v":2515655},{"$f":"SUM(D33:D43)","v":2481217},{"$f":"SUM(E33:E43)","v":0},{"$f":"SUM(F33:F43)","v":108}]
[]
[null,"Total Exclusions",{"$f":"SUM(C29,C44)","v":9191914},{"$f":"SUM(D29,D44)","v":8822626},{"$f":"SUM(E29,E44)","v":334850}]
[]
[null,"D) Projected 2018-19 Enrollment"]
[null,"Total District K-12 Enrollment",905]
[null,"Total District Pre-K Enrollment",30]
[null,"Total Preschool Special Education Enrollment",0]
[null,"Total District Enrollment",{"$f":"SUM(C49:C51)","v":935}]
[]
[null,"Total Funding Allocated to Individual Schools",{"$f":"C18-C46","v":18681012},{"$f":"D18-D46","v":18020050},{"$f":"E18-E46","v":695400}]
[null,"Total Allocated Funding per Pupil",{"$f":"IFERROR(C54/$C$52,\"\")","v":19979.691978609626},{"$f":"IFERROR(SUM(D54)/SUM($C$52),\"\")","v":19272.780748663103},743.7433155080214]
[]
[null,"III) Central District Costs Included in School Allocations"]
[null,null,null,"Funding Source",null,"Total Staff"]
[null,"A) General Support Costs","Total Spending","State/Local","Federal","(FTE Basis)"]
[null,"Board of Education ",18490,18490,0,0.2]
[null,"Central Personnel",709979,709979,0,7]
[null,"Operation and Maintenance of Plant",1284100,1284100,0,18]
[null,"Other Central Services",1475117,1475117,0,3]
[null,"Employee Benefits for General Support Staff (see IV below)",519164,519164,0]
[null,"Total General Support Costs",{"$f":"SUM(C60:C64)","v":4006850},{"$f":"SUM(D60:D64)","v":4006850},0,{"$f":"SUM(F60:F63)","v":28.2}]
[null,"Total General Support Costs per Pupil",{"$f":"IFERROR(C65/$C$52,\"\")","v":4285.4010695187162},{"$f":"IFERROR(D65/$C$52,\"\")","v":4285.4010695187162},0]
[]
[null,null,null,"Funding Source",null,"Total Staff"]
[null,"B) District Academic Support Costs","Total Spending","State/Local","Federal","(FTE Basis)"]
[null,"Curriculum Development & Supervision",20000,20000,0,0.2]
[null,"Research, Planning & Evaluation",0,0,0,0]
[null,"In-Service Training",0,0,0,0]
[null,"Employee Benefits for District Academic Support Staff (see IV below)",11300,11300,0]
[null,"Total District Academic Support Costs",{"$f":"SUM(C70:C73)","v":31300},{"$f":"SUM(D70:D73)","v":31300},0,{"$f":"SUM(F70:F72)","v":0.2}]
[null,"Total District Academic Support Costs per Pupil",{"$f":"IFERROR(C74/$C$52,\"\")","v":33.475935828877006},{"$f":"IFERROR(D74/$C$52,\"\")","v":33.475935828877006},{"$f":"IFERROR(E74/$C$52,\"\")","v":0}]
[]
[null,"C) Other Post-Employment Benefits (OPEB)",353210,353210,0]
[null,"Total OPEB per Pupil",{"$f":"IFERROR(C77/$C$52,\"\")","v":377.76470588235293},{"$f":"IFERROR(D77/$C$52,\"\")","v":377.76470588235293},0]
[]
[null,"Total Central District Costs Included in School Allocations",{"$f":"SUM(C65,C74,C77)","v":4391360},{"$f":"SUM(D65,D74,D77)","v":4391360},0]
[null,"Total Central District Costs per Pupil",{"$f":"SUM(C66,C75,C78)","v":4696.6417112299459},{"$f":"SUM(D66,D75,D78)","v":4696.6417112299459},0]
[]
[null,"Total Funding Allocated to Individual Schools excl. Central Costs",{"$f":"C54-C80","v":14289652},{"$f":"D54-D80","v":13628690},695400]
[null,"Total Allocated Funding per Pupil",{"$f":"IFERROR(C83/$C$52,\"\")","v":15283.05026737968}]
[]
[null,"IV) District Average Fringe Rate for Allocation of Employee Benefits"]
[null,"Total Employee Benefits in General Fund & Special Aid Fund",6069265]
[null,"Other Post-Employment Benefits",{"$f":"C77","v":353210}]
[null,"Total Employee Benefits for Active Employees",{"$f":"C87-C88","v":5716055}]
[null,"Total Personal Service in General Fund & Special Aid Fund",10115085]
[null,"District Average Fringe Rate",{"$f":"IFERROR(C89/C90,\"\")","v":0.56510202336411408}]

{"sheet":"Part-B","index":1,"n_rows":12,"n_cols":23,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,4,5,5],[5,10,5,15],[5,16,5,22],[5,6,5,9]]}
["Part B - Basic School-Level Information"]
["Number of district-operated schools:",null,4]
["Does the district have local school codes?",null,"Yes"]
[]
[]
[null,null,null,null,"Grade Span (excl. Pre-K)",null,"School Status",null,null,null,"Projected Enrollment & Demographics",null,null,null,null,null,"Projected Staffing (FTE Basis)"]
["BEDS Code","School Name","Local School Code","School Type","Lowest Grade","Highest Grade","Does this school serve its full planned grade span? (Y/N)","If no, is this school opening this school year? (Y/N)","Is the school scheduled to close? (Y/N)","If so, what year?","K-12 Enrollment","Pre-K\nEnrollment","Preschool Special Ed Enrollment","K-12\nFRPL\nCount","K-12\nELL \nCount","K-12\nSWD\nCount","Classroom Teachers w/ 0-3 Years Experience","Classroom Teachers w/ More than 3 Years Experience","Para-\nprofessional Classroom Staff","Principals & Other Admin Staff","Pupil Support Services Staff","All Remaining Staff","Total Staff"]
["080601040001","Primary School","02","Elementary School","K",2,"Yes",null,"No",null,200,30,0,120,0,3,3,21,18,1,2,1,{"$f":"SUM(Q8:V8)","v":46}]
["080601040002","Intermediate School","03","Elementary School",3,5,"Yes",null,"No",null,215,0,0,112,0,6,2,18,12,1,2,1,36]
["080601040003","High School","05","Senior High School",9,12,"Yes",null,"No",null,280,0,0,140,0,33,3,28,3,1,3,3,{"$f":"SUM(Q10:V10)","v":41}]
["080601040004","Middle School","04","Middle/Junior High School",6,8,"Yes",null,"No",null,210,0,0,109,0,8,2,19,5,1,2,3,{"$f":"SUM(Q11:V11)","v":32}]
["District Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K8:K11)","v":905},30,0,481,0,50,10,86,38,4,9,8,155]

{"sheet":"Part-C","index":2,"n_rows":12,"n_cols":25,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,9,4,16],[4,3,4,8],[4,20,4,21],[5,3,5,4],[5,9,5,10],[5,11,5,12],[5,13,5,15],[4,17,4,19]]}
["Part C - Basic School-Level Allocations"]
[]
["Number of district-operated schools:",null,{"$f":"'Part-B'!$C$2","v":4}]
[]
[null,null,null,"School Allocation by Object (excl. Central Costs)",null,null,null,null,null,"School Allocation by Purpose (excl. Central Costs)",null,null,null,null,null,null,null,"Funding Source by School",null,null,"Per Pupil Allocation"]
[null,null,null,"Personal Service",null,null,null,null,null,"General Education",null,"Special Education",null,"Instructional Support"]
["BEDS Code","School Name","Local School Code","Classroom Teachers","All Other Salaries","Employee Benefits","BOCES Services","All Other","Total Allocation by Object","Grades K-12","Pre-K","Grades K- 12","Preschool","School Administration","Instructional Media","Pupil\nSupport\nServices","Total Allocation by Purpose","State & Local Funding","Federal \nFunding","Total Funding Source by School","State & Local\nFunding per Pupil","Federal Funding \nper Pupil","Central District Costs","Total School Allocation w/ Central District Costs","Total School Funding per Pupil"]
[{"$f":"IF(ISBLANK(TableB[[#This Row],[BEDS Code]]),\"\",TableB[[#This Row],[BEDS Code]])","v":"080601040001"},{"$f":"IF(ISBLANK(TableB[[#This Row],[School Name]]),\"\",TableB[[#This Row],[School Name]])","v":"Primary School"},{"$f":"IF(ISBLANK(TableB[[#This Row],[Local School Code]]),\"\",TableB[[#This Row],[Local School Code]])","v":"02"},1642758,680667,{"$f":"IFERROR(SUM(TableC[[#This Row],[Classroom Teachers]:[All Other Salaries]])*'Part-A'!$C$91,0)","v":1312972.1686347667},159796,56631,{"$f":"SUM(D8:H8)","v":3852824.1686347667},2785770,173521,590441,0,125861,30638,146592,{"$f":"SUM(J8:P8)","v":3852823},3684073,157160,{"$f":"SUM(TableC[[#This Row],[State & Local Funding]:[Federal \nFunding]])","v":3841233},{"$f":"IFERROR(TableC[[#This Row],[State & Local Funding]]/SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":16017.708695652174},{"$f":"IFERROR(TableC[[#This Row],[Federal \nFunding]]/SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":683.304347826087},{"$f":"IFERROR(CentralCostperPupil*SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":1080227.5935828877},{"$f":"SUM(Q8,W8)","v":4933050.5935828872},{"$f":"IFERROR(TableC[[#This Row],[Total School Allocation w/ Central District Costs]]/SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":21448.046059056032}]
[{"$f":"IF(ISBLANK(TableB[[#This Row],[BEDS Code]]),\"\",TableB[[#This Row],[BEDS Code]])","v":"080601040002"},{"$f":"IF(ISBLANK(TableB[[#This Row],[School Name]]),\"\",TableB[[#This Row],[School Name]])","v":"Intermediate School"},{"$f":"IF(ISBLANK(TableB[[#This Row],[Local School Code]]),\"\",TableB[[#This Row],[Local School Code]])","v":"03"},1429246,611002,{"$f":"IFERROR(SUM(TableC[[#This Row],[Classroom Teachers]:[All Other Salaries]])*'Part-A'!$C$91,0)","v":1152948.272964587},164865,63321,{"$f":"SUM(D9:H9)","v":3421382.272964587},2396028,0,682214,0,165509,30638,146992,{"$f":"SUM(J9:P9)","v":3421381},3252631,157856,{"$f":"SUM(TableC[[#This Row],[State & Local Funding]:[Federal \nFunding]])","v":3410487},{"$f":"IFERROR(TableC[[#This Row],[State & Local Funding]]/SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":15128.516279069767},{"$f":"IFERROR(TableC[[#This Row],[Federal \nFunding]]/SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":734.21395348837211},{"$f":"IFERROR(CentralCostperPupil*SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":1009777.9679144383},{"$f":"SUM(Q9,W9)","v":4431158.9679144379},{"$f":"IFERROR(TableC[[#This Row],[Total School Allocation w/ Central District Costs]]/SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":20610.041711229944}]
[{"$f":"IF(ISBLANK(TableB[[#This Row],[BEDS Code]]),\"\",TableB[[#This Row],[BEDS Code]])","v":"080601040003"},{"$f":"IF(ISBLANK(TableB[[#This Row],[School Name]]),\"\",TableB[[#This Row],[School Name]])","v":"High School"},{"$f":"IF(ISBLANK(TableB[[#This Row],[Local School Code]]),\"\",TableB[[#This Row],[Local School Code]])","v":"05"},1730916,449565,{"$f":"IFERROR(SUM(TableC[[#This Row],[Classroom Teachers]:[All Other Salaries]])*'Part-A'!$C$91,0)","v":1232194.2250070069},303865,182794,3899334.2250070069,2860490,0,197157,0,181721,30138,629469,3898975,3696147,212097,{"$f":"SUM(TableC[[#This Row],[State & Local Funding]:[Federal \nFunding]])","v":3908244},{"$f":"IFERROR(TableC[[#This Row],[State & Local Funding]]/SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":13200.525},{"$f":"IFERROR(TableC[[#This Row],[Federal \nFunding]]/SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":757.48928571428576},{"$f":"IFERROR(CentralCostperPupil*SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":1315059.6791443848},5214034.6791443843,{"$f":"IFERROR(TableC[[#This Row],[Total School Allocation w/ Central District Costs]]/SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":18621.55242551566}]
[{"$f":"IF(ISBLANK(TableB[[#This Row],[BEDS Code]]),\"\",TableB[[#This Row],[BEDS Code]])","v":"080601040004"},{"$f":"IF(ISBLANK(TableB[[#This Row],[School Name]]),\"\",TableB[[#This Row],[School Name]])","v":"Middle School"},{"$f":"IF(ISBLANK(TableB[[#This Row],[Local School Code]]),\"\",TableB[[#This Row],[Local School Code]])","v":"04"},1175367,667998,{"$f":"IFERROR(SUM(TableC[[#This Row],[Classroom Teachers]:[All Other Salaries]])*'Part-A'!$C$91,0)","v":1041689.2912985901},123915,107142,{"$f":"SUM(D11:H11)","v":3116111.2912985901},1943662,0,573810,0,160010,30138,408853,{"$f":"SUM(J11:P11)","v":3116473},2961401,168287,{"$f":"SUM(TableC[[#This Row],[State & Local Funding]:[Federal \nFunding]])","v":3129688},{"$f":"IFERROR(TableC[[#This Row],[State & Local Funding]]/SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":14101.909523809523},{"$f":"IFERROR(TableC[[#This Row],[Federal \nFunding]]/SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":801.36666666666667},{"$f":"IFERROR(CentralCostperPupil*SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":986294.7593582886},{"$f":"SUM(Q11,W11)","v":4102767.7593582887},{"$f":"IFERROR(TableC[[#This Row],[Total School Allocation w/ Central District Costs]]/SUM(TableB[[#This Row],[K-12 Enrollment]:[Preschool Special Ed Enrollment]]),\"\")","v":19536.989330277564}]
["District Total",null,null,{"$f":"SUM(D8:D11)","v":5978287},2409232,4739803.9579049507,752441,409888,14289651.957904952,9985950,173521,2043622,0,633101,121552,1331906,14289652,13594252,695400,14289652,null,null,{"$f":"SUM(W8:W11)","v":4391359.9999999991},{"$f":"SUM(X8:X11)","v":18681012}]

{"sheet":"Part-D","index":3,"n_rows":19,"n_cols":25,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,5,14,9],[14,10,14,13],[4,5,4,13],[5,22,5,24],[5,5,5,9],[5,10,5,13],[4,14,4,24],[5,15,5,21]]}
["Part D - School-Level Spending on Prekindergarten and Community Schools Programming"]
[]
["Number of district-operated schools:",null,null,{"$f":"'Part-B'!$C$2","v":4}]
[]
[null,null,null,null,null,"Prekindergarten Programs",null,null,null,null,null,null,null,null,"Student, Family, and Community Schools Programs"]
[null,null,null,null,null,"Projected Pre-K Enrollment",null,null,null,null,"Projected Pre-K Funding",null,null,null,null,"Spending by Purpose",null,null,null,null,null,null,"Funding Source by Program"]
["BEDS Code","School Name","Local School Code","Does this school offer a Pre-K program? (Y/N)","Does this school offer student/family support or community schools services? (Y/N)","4-Year-Old \nFull-Day","4-Year-Old \nHalf-Day","3-Year-Old \nFull-Day","3-Year-Old \nHalf-Day","Total Pre-K Enrollment","State Grants","Other State &  Local Funding","Federal  Funding","Total Pre-K Spending","Community Schools Site Coordinator (FTE Basis)","Enriched Academic Services","Health, Mental Health/\nCounseling, Dental Care","Nutrition Services","Legal Services","After-School Programs/\nExtended Day Programs","All Other","Total Community Schools Spending","Foundation Aid Community Schools Set-Aside","Other State & Local Funding","Federal \nFunding"]
[{"$f":"IF(ISBLANK(TableB[[#This Row],[BEDS Code]]),\"\",TableB[[#This Row],[BEDS Code]])","v":"080601040001"},{"$f":"IF(ISBLANK(TableB[[#This Row],[School Name]]),\"\",TableB[[#This Row],[School Name]])","v":"Primary School"},{"$f":"IF(ISBLANK(TableB[[#This Row],[Local School Code]]),\"\",TableB[[#This Row],[Local School Code]])","v":"02"},"Yes","No",0,30,0,0,{"$f":"SUM(F8:I8)","v":30},123521,50000,0,{"$f":"SUM(K8:M8)","v":173521},null,null,null,null,null,null,null,{"$f":"SUM(P8:U8)","v":0}]
[{"$f":"IF(ISBLANK(TableB[[#This Row],[BEDS Code]]),\"\",TableB[[#This Row],[BEDS Code]])","v":"080601040002"},{"$f":"IF(ISBLANK(TableB[[#This Row],[School Name]]),\"\",TableB[[#This Row],[School Name]])","v":"Intermediate School"},{"$f":"IF(ISBLANK(TableB[[#This Row],[Local School Code]]),\"\",TableB[[#This Row],[Local School Code]])","v":"03"},"No","No",null,null,null,null,{"$f":"SUM(F9:I9)","v":0},null,null,null,{"$f":"SUM(K9:M9)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(P9:U9)","v":0}]
[{"$f":"IF(ISBLANK(TableB[[#This Row],[BEDS Code]]),\"\",TableB[[#This Row],[BEDS Code]])","v":"080601040003"},{"$f":"IF(ISBLANK(TableB[[#This Row],[School Name]]),\"\",TableB[[#This Row],[School Name]])","v":"High School"},{"$f":"IF(ISBLANK(TableB[[#This Row],[Local School Code]]),\"\",TableB[[#This Row],[Local School Code]])","v":"05"},"No","No",null,null,null,null,{"$f":"SUM(F10:I10)","v":0},null,null,null,{"$f":"SUM(K10:M10)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(P10:U10)","v":0}]
[{"$f":"IF(ISBLANK(TableB[[#This Row],[BEDS Code]]),\"\",TableB[[#This Row],[BEDS Code]])","v":"080601040004"},{"$f":"IF(ISBLANK(TableB[[#This Row],[School Name]]),\"\",TableB[[#This Row],[School Name]])","v":"Middle School"},{"$f":"IF(ISBLANK(TableB[[#This Row],[Local School Code]]),\"\",TableB[[#This Row],[Local School Code]])","v":"04"},"No","No",null,null,null,null,{"$f":"SUM(F11:I11)","v":0},null,null,null,{"$f":"SUM(K11:M11)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(P11:U11)","v":0}]
["Total in District Schools",null,null,null,null,{"$f":"SUM(F8:F11)","v":0},30,0,0,30,123521,50000,0,173521,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,null,"Projected Pre-K CBO Enrollment",null,null,null,null,"Projected Pre-K CBO Funding"]
[null,null,null,null,"# of CBO Sites","4-Year-Old \nFull-Day","4-Year-Old \nHalf-Day","3-Year-Old \nFull-Day","3-Year-Old \nHalf-Day","Total Pre-K Enrollment","State Grants","Other State & Local Funding","Federal Funding","Total Pre-K Spending"]
["Total in Prekindergarten Community-Based Organizations",null,null,null,0,null,null,null,null,{"$f":"SUM(F17:I17)","v":0},null,null,null,{"$f":"SUM(K17:M17)","v":0}]
[]
["District Total with CBOs",null,null,null,null,{"$f":"F12+F17","v":0},30,0,0,30,123521,50000,0,173521]

{"sheet":"Part-E","index":4,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Part E - Locally Implemented Funding Formula"]
["Are schools allocated a sizeable portion of their funding via a locally implemented formula?",null,null,null,"No"]
["Number of district-operated schools:",null,{"$f":"'Part-B'!$C$2","v":4}]
[]
[]
[]
["BEDS Code","School Name","Local School Code","Local Formula\nAllocation","Allocation If Local Formula Fully Funded","Difference","% Funded","Total Funding (See Part C)","Local Formula as % of Total Funding","Other Funding"]
[{"$f":"IF(ISBLANK(TableB[[#This Row],[BEDS Code]]),\"\",TableB[[#This Row],[BEDS Code]])","v":"080601040001"},{"$f":"IF(ISBLANK(TableB[[#This Row],[School Name]]),\"\",TableB[[#This Row],[School Name]])","v":"Primary School"},{"$f":"IF(ISBLANK(TableB[[#This Row],[Local School Code]]),\"\",TableB[[#This Row],[Local School Code]])","v":"02"},null,null,{"$f":"D8-E8","v":0},{"$f":"IFERROR(D8/E8,\"\")","v":""},{"$f":"'Part-C'!I8","v":3852824.1686347667},{"$f":"IFERROR(D8/H8,\"\")","v":0},{"$f":"H8-D8","v":3852824.1686347667}]
[{"$f":"IF(ISBLANK(TableB[[#This Row],[BEDS Code]]),\"\",TableB[[#This Row],[BEDS Code]])","v":"080601040002"},{"$f":"IF(ISBLANK(TableB[[#This Row],[School Name]]),\"\",TableB[[#This Row],[School Name]])","v":"Intermediate School"},{"$f":"IF(ISBLANK(TableB[[#This Row],[Local School Code]]),\"\",TableB[[#This Row],[Local School Code]])","v":"03"},null,null,{"$f":"D9-E9","v":0},{"$f":"IFERROR(D9/E9,\"\")","v":""},{"$f":"'Part-C'!I9","v":3421382.272964587},{"$f":"IFERROR(D9/H9,\"\")","v":0},{"$f":"H9-D9","v":3421382.272964587}]
[{"$f":"IF(ISBLANK(TableB[[#This Row],[BEDS Code]]),\"\",TableB[[#This Row],[BEDS Code]])","v":"080601040003"},{"$f":"IF(ISBLANK(TableB[[#This Row],[School Name]]),\"\",TableB[[#This Row],[School Name]])","v":"High School"},{"$f":"IF(ISBLANK(TableB[[#This Row],[Local School Code]]),\"\",TableB[[#This Row],[Local School Code]])","v":"05"},null,null,0,"",{"$f":"'Part-C'!I10","v":3899334.2250070069},0,3899334.2250070069]
[{"$f":"IF(ISBLANK(TableB[[#This Row],[BEDS Code]]),\"\",TableB[[#This Row],[BEDS Code]])","v":"080601040004"},{"$f":"IF(ISBLANK(TableB[[#This Row],[School Name]]),\"\",TableB[[#This Row],[School Name]])","v":"Middle School"},{"$f":"IF(ISBLANK(TableB[[#This Row],[Local School Code]]),\"\",TableB[[#This Row],[Local School Code]])","v":"04"},null,null,{"$f":"D11-E11","v":0},{"$f":"IFERROR(D11/E11,\"\")","v":""},{"$f":"'Part-C'!I11","v":3116111.2912985901},{"$f":"IFERROR(D11/H11,\"\")","v":0},{"$f":"H11-D11","v":3116111.2912985901}]
["District Total",null,null,{"$f":"SUM(D8:D11)","v":0},{"$f":"SUM(E8:E11)","v":0},{"$f":"D12-E12","v":0},{"$f":"IFERROR(D12/E12,\"\")","v":""},{"$f":"SUM(H8:H11)","v":14289651.957904952},{"$f":"IFERROR(D12/H12,\"\")","v":0},{"$f":"H12-D12","v":14289651.957904952}]

{"sheet":"Data Validation","index":5,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,1,2]]}
[null,"Data Validation"]
[]
[null,"Part-A: District Level Information"]
[null,"#1","Is the General Fund the largest fund?",{"$f":"IF('Part-A'!C14=MAX('Part-A'!C14:C17),\"Pass\",\"Fail\")","v":"Pass"}]
[null,"Part-B: Basic School-Level Information"]
[null,"#2","Do the separately reported enrollment totals match?",{"$f":"IF(D7=D8,\"Pass\",\"Fail\")","v":"Pass"}]
[null,null,"Total District Enrollment (Part A)",{"$f":"'Part-A'!C52","v":935}]
[null,null,"Total District Enrollment (Part B)",{"$f":"SUM('Part-B'!K12:M12)","v":935}]
[null,"Part-C: Basic School-Level Allocations"]
[null,"#3","Do the reported school allocations match?",{"$f":"IF(AND(ROUND(D11,0)=D12,D12=D13),\"Pass\",\"Fail\")","v":"Pass"}]
[null,null,"School Allocation by Object (Col I)",{"$f":"'Part-C'!I12","v":14289651.957904952}]
[null,null,"School Allocation by Purpose (Col Q)",{"$f":"'Part-C'!Q12","v":14289652}]
[null,null,"Total Funding Source by School (Col T)",{"$f":"'Part-C'!T12","v":14289652}]
[null,"#4","Do the separately reported funding totals match?",{"$f":"IF(ROUND(D15,0)=ROUND(D16,0),\"Pass\",\"Fail\")","v":"Pass"}]
[null,null,"Total Funding Allocated to Individual Schools (Part A)",{"$f":"'Part-A'!C54","v":18681012}]
[null,null,"Total School Allocation w/ Central Costs (Part C)",{"$f":"'Part-C'!X12","v":18681012}]
[null,"#5","Are estimated employee benefits less than reported salaries?",{"$f":"IF(OR(D19<D18,SUM(D18:D19)=0),\"Pass\",\"Fail\")","v":"Pass"}]
[null,null,"Total Salaries",{"$f":"SUM('Part-C'!D12:E12)","v":8387519}]
[null,null,"Total Employee Benefits",{"$f":"'Part-C'!F12","v":4739803.9579049507}]
[null,"Part-D: School-Level Spending on Pre-K and Community Schools"]
[null,"#6","Do the separately reported Pre-K enrollment totals match?",{"$f":"IF(D22=D23,\"Pass\",\"Fail\")","v":"Pass"}]
[null,null,"Total Pre-K Enrollment (Part B, Col H)",{"$f":"'Part-B'!L12","v":30}]
[null,null,"Total Pre-K Enrollment (Part D, Col K)",{"$f":"'Part-D'!J12","v":30}]
[null,"#7","Do the separately reported Pre-K funding totals match?",{"$f":"IF(D25=D26,\"Pass\",\"Fail\")","v":"Pass"}]
[null,null,"Total Pre-K Funding (Part C, Col K)",{"$f":"'Part-C'!K12","v":173521}]
[null,null,"Total Pre-K Funding (Part D, Col N)",{"$f":"'Part-D'!N12","v":173521}]
[null,"Employee Benefits Validation"]
[null,"#8","Are total employee benefits for active employees fully allocated?",{"$f":"IF(D29=ROUND(SUM(D30:D33),0),\"Pass\",\"Fail\")","v":"Pass"}]
[null,null,"Total Employee Benefits for Active Employees (Part A, Section IV)",{"$f":"'Part-A'!C89","v":5716055}]
[null,null,"Employee Benefits (Part A, Section II-A)",{"$f":"'Part-A'!C28","v":445787}]
[null,null,"Employee Benefits (Part A, Section III-A)",{"$f":"'Part-A'!C64","v":519164}]
[null,null,"Employee Benefits (Part A, Section III-B)",{"$f":"'Part-A'!C73","v":11300}]
[null,null,"Total Employee Benefits (Part C, Col F)",{"$f":"'Part-C'!F12","v":4739803.9579049507}]
[null,"#9","Was the district average fringe rate used to estimate employee benefits?",{"$f":"IF(D37=D38,\"Pass\",\"Fail\")","v":"Pass"}]
[null,null,"Total Employee Benefits (Part C, Col F)",{"$f":"'Part-C'!F12","v":4739803.9579049507}]
[null,null,"Total Salaries (Part C, Col D and E)",{"$f":"SUM('Part-C'!D12:E12)","v":8387519}]
[null,null,"Calculated Fringe Rate",{"$f":"IFERROR(D35/D36,\"\")","v":0.56510202336411408}]
[null,null,"District Average Fringe Rate",{"$f":"'Part-A'!C91","v":0.56510202336411408}]

{"sheet":"Drop-downs","index":6,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[null,"School Year",null,"School Type",null,"Grades",null,"Year Closure","First Year of Operations",null,"Community School?",null,"Funding Formula?"]
[null,"2017-18",null,"Pre-K Only",null,"K",null,2018,2015,null,"Yes",null,"Yes"]
[null,"2018-19",null,"Elementary School",null,1,null,2019,2016,null,"No",null,"No"]
[null,null,null,"Middle/Junior High School",null,2,null,2020,2017]
[null,null,null,"Junior-Senior High School",null,3,null,2021]
[null,null,null,"Senior High School",null,4]
[null,null,null,"K-8 School",null,5]
[null,null,null,"K-12 School",null,6]
[null,null,null,"Other",null,7]
[null,null,null,null,null,8]
[null,null,null,null,null,9]
[null,null,null,null,null,10]
[null,null,null,null,null,11]
[null,null,null,null,null,12]
[null,null,null,null,null,"District 75"]
[null,null,null,null,null,"Other"]
[]
[]
[]
[]
[]
[null,null,null,"#oxford,stinks"]